SET IMPLICIT_TRANSACTIONS OFF
USE master
SELECT
	[Object Type]		= cp.objtype,
	[Object Name]		= OBJECT_NAME(st.objectid,st.[dbid]),
	[Database Name]		= DB_NAME(st.[dbid]),
	[Execution Count]	= cp.usecounts,
	[Query Text]		= st.[text],
	[Query Plan]		= qp.query_plan
  FROM sys.dm_exec_cached_plans AS cp
	CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st
	CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) AS qp
  WHERE cp.objtype = 'Proc'
	AND OBJECT_NAME(st.objectid,st.dbid) = 'YourObjectName' 
GO